<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主要内容区main</title>
<link href="../../public/admin/css/css.css" type="text/css" rel="stylesheet" />
<link href="../../public/admin/css/css.css" type="text/css" rel="stylesheet" />
<link rel="shortcut icon" href="../../public/admin/img/main/favicon.ico" />
<style>
body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
#searchmain{ font-size:12px;}
#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF}
#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(../../public/admin/img/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
#search a.add{ background:url(../../public/admin/img/main/add.jpg) no-repeat 0px 6px; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF}
#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
#main-tab th{ font-size:12px; background:url(../../public/admin/img/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
#main-tab td{ font-size:12px; line-height:40px;}
#main-tab td a{ font-size:12px; color:#548fc9;}
#main-tab td a:hover{color:#565656; text-decoration:underline;}
.bordertop{ border-top:1px solid #ebebeb}
.borderright{ border-right:1px solid #ebebeb}
.borderbottom{ border-bottom:1px solid #ebebeb}
.borderleft{ border-left:1px solid #ebebeb}
.gray{ color:#dbdbdb;}
td.fenye{ padding:10px 0 0 0; text-align:right;}
.bggray{ background:#f9f9f9}
#addinfo{ padding:0 0 10px 0;}
input.text-word{ width:50px; height:24px; line-height:20px; border:#ebebeb 1px solid; background:#FFF; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; text-align:center; color:#666}
.tda{width:100px;}
.tdb{ padding-left:20px;}
td#xiugai{ padding:10px 0 0 0;}
td#xiugai input{ width:100px; height:40px; line-height:30px; border:none; border:1px solid #cdcdcd; background:#e6e6e6; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#969696; float:left; margin:0 10px 0 0; display:inline; cursor:pointer; font-size:14px; font-weight:bold;}
</style>
</head>
<body>
<!--main_top-->

<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
  <tr>
    <td width="99%" align="left" valign="top" id="addinfo">您的位置：板块管理&nbsp;&nbsp;>&nbsp;&nbsp;浏览板块</td>
  </tr>

  <tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
      <tr>
        <th align="center" valign="middle" class="borderright tda">顺序</th>
        <th align="center" valign="middle" class="borderright tda">分类树</th>
        <th align="center" valign="middle" class="borderright tda">ID</th>
        <th align="center" valign="middle" class="borderright">板块名</th>
        <th align="center" valign="middle" class="borderright">状态</th>
        <th align="center" valign="middle" class="borderright">LOGO</th>
        <th align="center" valign="middle">栏目管理</th>
      </tr>



        <?php
        $link = mysqli_connect("localhost","root","") or die("数据连接失败");
        mysqli_set_charset($link,"utf8");
        mysqli_select_db($link,"bbs");
        $sql = "select *,concat(path,'-',id) as npath from type order by npath";
        $res = mysqli_query($link,$sql);
        $count = mysqli_num_rows($res);//总条数；
        $pages = ceil($count/5);//总页数；
        $page = isset($_GET['p']) ? $_GET['p'] : 1;
        if ($page < 1) {
          $page = 1;
        }
        if ($page > $count) {
          $page = $count;
        }
        $index = ($page - 1) * 5;
        $sql = "select *,concat(path,'-',id) as npath from type order by npath limit $index,5";

        $res = mysqli_query($link,$sql);
        $res = mysqli_query($link,$sql);
        if($res && mysqli_num_rows($res)>0){
          while($rows=mysqli_fetch_assoc($res)){
            $path="../../public/home/img/";
            $path = rtrim($path,'/').'/';
                if($rows['status'] ==1){
                  $status = '开启';
                }else{
                  $status = '关闭';
                }
            echo "<tr class='bggray'>";
              echo "<td align='center' valign='middle' class='borderbottom'>{$rows['npath']}</td>";
              if($rows['pid']==0){
                echo "<td align='left' valign='middle' class='borderbottom tdb'><img src='../../public/admin/img/main/dirfirst.gif' width='15' height='13'></td>";
                echo "<td align='center' valign='middle' class='borderbottom'>{$rows['id']}</td>";

                echo "<td align='left' valign='middle' class='borderbottom tdb'>{$rows['name']}</td>";
                echo "<td align='left' valign='middle' class='borderbottom tdb'>{$status}</td>";
                echo "<td align='left' valign='middle' class='borderbottom tdb'>".'无'."</td>";
                echo "<td align='center' valign='middle' class='borderbottom'><a href='edit.php?id={$rows['id']}' target='mainFrame' onFocus='this.blur()' class='add'>修改</a><span class='gray'>&nbsp;|&nbsp;</span><a href='show.php?fname={$rows['name']}' target='mainFrame' onFocus='this.blur()' class='add'>添加子模块</a><span class='gray'>&nbsp;|&nbsp;</span><a href='typeaction.php?a=del&&id={$rows['id']}&path={$rows['path']}' target='mainFrame' onFocus='this.blur()' class='add'>删除</a></td>";
                echo "</tr>";
              }else if($rows['pid']!=0){
                echo "<td align='left' valign='middle' class='borderbottom tdb'><img src='../../public/admin/img/main/dirsecond.gif' width='30' height='25'></td>";
                echo "<td align='center' valign='middle' class='borderbottom'>{$rows['id']}</td>";

                echo "<td align='left' valign='middle' class='borderbottom tdb'>{$rows['name']}</td>";
                echo "<td align='left' valign='middle' class='borderbottom tdb'>{$status}</td>";
                echo "<td align='left' valign='middle' class='borderbottom tdb'><img src={$path}{$rows['blogo']}></td>";
                echo "<td align='center' valign='middle' class='borderbottom'><a href='edit.php?id={$rows['id']}' target='mainFrame' onFocus='this.blur()' class='add'>修改</a><span class='gray'>&nbsp;|&nbsp;</span><a href='typeaction.php?a=del&&id={$rows['id']}' target='mainFrame' onFocus='this.blur()' class='add'>删除</a></td>";
                echo "</tr>";
              }


        }

      }
      mysqli_free_result($res);
      mysqli_close($link);
      ?>

</table>
      <br>
      <div style="margin-left: 400px">
        <ul style="list-style: none;">
          <li style="float: left">当前数据:<?php echo $count;?>条,</li>
          <li style="float:left">第<?php echo $page;?>/<?php echo $pages;?>页,</li>
          <li style="float:left"><a href="main_menu.php?p=1&name=<?php echo @$_GET['name']?>">首页</a>&nbsp;</li>
          <li style="float:left"><a href="main_menu.php?p=<?php echo $page-1;?>&name=<?php echo @$_GET['name']?>">上一页</a>&nbsp;</li>
          <li style="float:left"><a href="main_menu.php?p=<?php echo $page+1>$pages?$pages:$page+1;?>&name=<?php echo @$_GET['name']?>">下一页</a>&nbsp;</li>
          <li style="float:left"><a href="main_menu.php?p=<?php echo $pages;?>&name=<?php echo @$_GET['name']?>">尾页</a>&nbsp;</li>
        </ul>
      </div>
</body>
</html>